Hi Am getting the following error message when the sql agent runs the deployed SSIS Package. We are loading records from DB2 Database (source) to MS Sql Server 2008 (Destination). Error Error: 2012-07-31 15:20:37.67 Code: 0xC0202009 Source: StgRating RTG_DET_TABL [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E31. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E31 Description: "[DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00C90084", type of resource: "00000230", and resource name: "4K ". SQLSTATE=57011 ". ilikemicrosoft

Does the package work when you execute it in BIDS? In the SQL Server Agent job, did you specify a proxy to run the package?MCTS, MCITP - Please mark posts as answered where appropriate.

It works when we run the package in BIDS... We have more than 20 dataflow task ...some of them are working but some of them throwing the error message which i posted earlier. I have no idea about the proxy thing...ilikemicrosoft

how to use proxy...could you help me out..in the deployment environment we need to use windows authentication not mix mode...ilikemicrosoft

First Google result for sql server agent proxy tutorial: http://www.mssqltips.com/sqlservertutorial/220/scheduling-ssis-packages-with-sql-server-agent/ MCTS, MCITP - Please mark posts as answered where appropriate.